Load Data into Power BI Desktop 7

Step-1 Load Data into Power BI Desktop

  1. Open Power Bi Desktop, from the Home tab and click on Get Data
  2. Select 'SQL Server' from the options and then connect with Colaberry Server.

Use This Info to connect with Server

SQL Server Connection

Server: hypv8669.hostedbyappliedi.net

Username: ColaberryPowerBIReporting

pw: Colaberry99

Database NameColaberryPowerBIReporting

  1. This will bring you to a list of Database then Select  (ColaberryPowerBIReporting) Database .
  2. under ColaberryPowerBIReporting Database select two of the tables 

                 =>TierII_CAP    &   

                                                   => TierII_CAP_Active

       5.Click on the Load button to load the data into Power BI Desktop.



Create a Calendar table and the calculation that is attached below.

  1. Click on the Data view from the left menu.
  2. Then select the Modeling tab from the top menu. Click on New Table.
  3. Enter the DAX expression below to create a calendar Table.

Calendar Table DAX


CALENDAR = ADDCOLUMNS(                                                                                                          

          CALENDAR("1-January-2018",TODAY()),                                                                                                       "Year", YEAR([Date]),

"Monthnumber",MONTH([Date]),                                                                                                                    "MonthNameShort", FORMAT ( [Date], "mmm" ),

"MonthNameLong",FORMAT ( [Date], "mmmm" ),                                                                                                      "DayOfWeekNumber", WEEKDAY ( [Date] ),                                                                                                           "DayOfWeek", FORMAT ( [Date], "dddd" ),                                                                                           "DayOfWeekShort",FORMAT ( [Date], "ddd" ),                                                                                                      "Quarter", "Q" & FORMAT ( [Date], "Q"),

"Year Quarter Name", FORMAT ( [Date], "YYYY" ) & "-Q" & FORMAT ( [Date], "Q"),                                                                  

"Year Quarter Number", YEAR( [Date]) * 100 + QUARTER( [Date]),

"Year Month Name", FORMAT( [Date], "mmm") & " " & YEAR( [Date]),

"Year Month Number", YEAR( [Date]) *100 + MONTH([Date]) )


 

To learn more about how to get data in power bi desktop , click below:

https://docs.microsoft.com/en-us/power-bi/connect-data/service-desktop-files